select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'DZ' order by rank asc limit 0,100 Surnames > D > DZ > DZU

Surnames > D > DZ > DZU

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
DA DC DE DH DI DJ DL DM DO DR DS DU DV DW DY DZ
DZA DZI DZU DZW DZY

Full Surname List Starting with DZU(Alphabetical)

DZUBA
DZUBAK
DZUBAY
DZUGAN
DZUL
DZURICK
DZURIK
DZURILLA
DZURIS
DZURKO

Top 100 Surnames in the 2010 US Census starting with DZU

SurnameCountRankWiki?
DZUL 381 54178 no
DZURILLA 212 87663 no
DZUBAK 181 99845 no
DZURKO 178 101247 no
DZURIS 143 120901 no
DZURIK 130 130610 no
DZUBA 130 130610 no
DZUGAN 128 132206 no
DZUBAY 126 133863 no
DZURICK 124 135593 no